{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/tz264/Library/CloudStorage/Dropbox/Analyst Reports 1/RFS/Table5.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 5 Sep 2025, 11:11:39

{com}. do "/var/folders/kf/76t78mtn1sx_dqv5bqhy95w80000gq/T//SD80608.000000"
{txt}
{com}. ***Table 5
. 
. *raw data not included
. 
. ****************report level measure
. ***report 
. cd "/Users/tz264/Library/CloudStorage/Dropbox/Analyst Reports and CC/culture-results/2024-10-15/measures"
{res}/Users/tz264/Library/CloudStorage/Dropbox/Analyst Reports and CC/culture-results/2024-10-15/measures
{txt}
{com}. 
. import delimited "report_measures.csv",clear
{res}{txt}(encoding automatically selected: ISO-8859-1)
{text}(95 vars, 86,112 obs)

{com}. 
. *#report with culture
. sum gvkey 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     86,112    46356.04    59884.01       1004     328795
{txt}
{com}. unique gvkey year 
{txt}Number of unique values of gvkey year is  {res}21242
{txt}Number of records is  {res}86112
{txt}
{com}. unique gvkey 
{txt}Number of unique values of gvkey is  {res}2747
{txt}Number of records is  {res}86112
{txt}
{com}. 
. *
. sum gvkey if top_cause_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     33,512    44907.43    59331.84       1004     328795
{txt}
{com}. sum gvkey if top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     53,455    45402.96    59569.27       1004     328795
{txt}
{com}. unique gvkey year if top_cause_type!=""
{txt}Number of unique values of gvkey year is  {res}13491
{txt}Number of records is  {res}33512
{txt}
{com}. unique gvkey year  if top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}16694
{txt}Number of records is  {res}53455
{txt}
{com}. unique gvkey  if top_cause_type!=""
{txt}Number of unique values of gvkey is  {res}2385
{txt}Number of records is  {res}33512
{txt}
{com}. unique gvkey  if top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}2553
{txt}Number of records is  {res}53455
{txt}
{com}. *either or 
. sum gvkey if top_cause_type!="" | top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     54,018    45344.93     59568.4       1004     328795
{txt}
{com}. unique gvkey year if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}16745
{txt}Number of records is  {res}54018
{txt}
{com}. unique gvkey  if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}2554
{txt}Number of records is  {res}54018
{txt}
{com}. 
. *with cause only 
. sum gvkey if top_cause_type!="" & top_consequence_type==""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}        563    39834.57    59279.88       1076     326688
{txt}
{com}. 
. *both 
. sum gvkey if top_cause_type!="" & top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     32,949    44994.11    59329.86       1004     328795
{txt}
{com}. unique gvkey year if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}13415
{txt}Number of records is  {res}32949
{txt}
{com}. unique gvkey  if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}2384
{txt}Number of records is  {res}32949
{txt}
{com}. 
. 
. 
. 
. 
. 
. 
. ***calls
. import delimited "component_measures.csv",clear
{res}{txt}(encoding automatically selected: ISO-8859-1)
{res}{text}(86 vars, 199,465 obs)

{com}. unique gvkey date
{txt}Number of unique values of gvkey date is  {res}101533
{txt}Number of records is  {res}199465
{txt}
{com}. gen year=substr(date,1,4)
{txt}
{com}.  unique gvkey year
{txt}Number of unique values of gvkey year is  {res}48192
{txt}Number of records is  {res}199465
{txt}
{com}.   
. unique gvkey date if top_cause_type!=""
{txt}Number of unique values of gvkey date is  {res}58535
{txt}Number of records is  {res}80156
{txt}
{com}. unique gvkey date  if top_consequence_type!=""
{txt}Number of unique values of gvkey date is  {res}80930
{txt}Number of records is  {res}128813
{txt}
{com}. unique gvkey year if top_cause_type!=""
{txt}Number of unique values of gvkey year is  {res}34485
{txt}Number of records is  {res}80156
{txt}
{com}. unique gvkey  year if top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}41239
{txt}Number of records is  {res}128813
{txt}
{com}. unique gvkey  if top_cause_type!=""
{txt}Number of unique values of gvkey is  {res}8835
{txt}Number of records is  {res}80156
{txt}
{com}. unique gvkey  if top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}9551
{txt}Number of records is  {res}128813
{txt}
{com}. 
. *either or 
. unique gvkey date if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey date is  {res}82008
{txt}Number of records is  {res}131212
{txt}
{com}. unique gvkey year if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}41514
{txt}Number of records is  {res}131212
{txt}
{com}. unique gvkey  if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}9576
{txt}Number of records is  {res}131212
{txt}
{com}. 
. *with cause only 
. sum gvkey if top_cause_type!="" & top_consequence_type==""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}      2,399    92941.64    91872.93       1045     332717
{txt}
{com}. 
. *both 
. unique gvkey date if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey date is  {res}57170
{txt}Number of records is  {res}77757
{txt}
{com}. unique gvkey year if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}34016
{txt}Number of records is  {res}77757
{txt}
{com}. unique gvkey  if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}8783
{txt}Number of records is  {res}77757
{txt}
{com}. 
. 
. ***review 
. import delimited "review_measures.csv",clear
{res}{txt}(encoding automatically selected: ISO-8859-1)
{res}{text}(85 vars, 1,180,561 obs)

{com}. unique review_id
{txt}Number of unique values of review_id is  {res}1180561
{txt}Number of records is  {res}1180561
{txt}
{com}. **# Bookmark #6
. unique gvkey 
{txt}Number of unique values of gvkey is  {res}4788
{txt}Number of records is  {res}1180561
{txt}
{com}. gen year=substr(date,1,4)
{txt}
{com}. tab year 

       {txt}year {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
       2008 {c |}{res}      9,004        0.76        0.76
{txt}       2009 {c |}{res}      8,459        0.72        1.48
{txt}       2010 {c |}{res}     12,799        1.08        2.56
{txt}       2011 {c |}{res}     13,831        1.17        3.73
{txt}       2012 {c |}{res}     31,717        2.69        6.42
{txt}       2013 {c |}{res}     40,513        3.43        9.85
{txt}       2014 {c |}{res}     69,215        5.86       15.72
{txt}       2015 {c |}{res}     96,573        8.18       23.90
{txt}       2016 {c |}{res}    111,770        9.47       33.36
{txt}       2017 {c |}{res}    115,015        9.74       43.11
{txt}       2018 {c |}{res}    109,381        9.27       52.37
{txt}       2019 {c |}{res}    116,883        9.90       62.27
{txt}       2020 {c |}{res}    131,636       11.15       73.42
{txt}       2021 {c |}{res}    226,796       19.21       92.63
{txt}       2022 {c |}{res}     86,969        7.37      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  1,180,561      100.00
{txt}
{com}. destring year,replace 
{txt}year: all characters numeric; {res}replaced {txt}as {res}int
{txt}
{com}. *keep in line with report sample
. drop if year>2020
{txt}(313,765 observations deleted)

{com}. 
.  unique gvkey year
{txt}Number of unique values of gvkey year is  {res}29081
{txt}Number of records is  {res}866796
{txt}
{com}.  unique gvkey 
{txt}Number of unique values of gvkey is  {res}4485
{txt}Number of records is  {res}866796
{txt}
{com}.  
.  sum gvkey if top_cause_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     81,154    74323.15     84141.2       1004     331191
{txt}
{com}.   sum gvkey if top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}    151,689    74287.51    83687.89       1004     331191
{txt}
{com}. unique gvkey year if top_cause_type!=""
{txt}Number of unique values of gvkey year is  {res}15998
{txt}Number of records is  {res}81154
{txt}
{com}. unique gvkey year  if top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}18959
{txt}Number of records is  {res}151689
{txt}
{com}. unique gvkey  if top_cause_type!=""
{txt}Number of unique values of gvkey is  {res}3240
{txt}Number of records is  {res}81154
{txt}
{com}. unique gvkey  if top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}3508
{txt}Number of records is  {res}151689
{txt}
{com}. 
. 
. *either or 
. sum gvkey if top_cause_type!="" | top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}    157,680    74365.02    83773.55       1004     331191
{txt}
{com}. unique gvkey year if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}19153
{txt}Number of records is  {res}157680
{txt}
{com}. unique gvkey  if top_cause_type!="" | top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}3527
{txt}Number of records is  {res}157680
{txt}
{com}. 
. *with cause only 
. sum gvkey if top_cause_type!="" & top_consequence_type==""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}      5,991    76327.45    85897.81       1004     326455
{txt}
{com}. 
. *both 
. sum gvkey if top_cause_type!="" & top_consequence_type!=""

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}gvkey {c |}{res}     75,163    74163.39    83998.13       1004     331191
{txt}
{com}. unique gvkey year if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey year is  {res}15576
{txt}Number of records is  {res}75163
{txt}
{com}. unique gvkey  if top_cause_type!="" & top_consequence_type!=""
{txt}Number of unique values of gvkey is  {res}3200
{txt}Number of records is  {res}75163
{txt}
{com}. 
. 
. ***
. 
{txt}end of do-file

{com}. log off
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/tz264/Library/CloudStorage/Dropbox/Analyst Reports 1/RFS/Table5.smcl
  {txt}log type:  {res}smcl
 {txt}paused on:  {res} 5 Sep 2025, 11:17:15
{txt}{.-}
{smcl}
{txt}{sf}{ul off}